Problem Note 47352: Using datetime values as arguments in the DATDIF() and YRDIF()
functions causes a "Floating Point Exception" error
Using either the DATDIF() or YRDIF() functions with datetime values as the arguments to the function might cause a "Floating Point Overflow" error. The arguments to these functions should be date values, not datetime values.
The "Floating Point Overflow" errors occur in DATA Step or the SQL procedure (PROC SQL), and only on AIX systems.
In PROC SQL, the following error is produced:
ERROR: Floating Point Overflow.
ERROR: Termination due to Floating Point Exception
If you are using a DATA Step, this error is produced:
ERROR: An unknown, abnormal error has occurred during execution at line xxx
column y.
ERROR: Termination due to Floating Point Exception
The correct behavior is that a note is written to the SAS log:
NOTE: Invalid argument to function Function Name. Missing values may be generated.
Operating System and Release Information
SAS System | Base SAS | z/OS | 9.1 TS1M3 SP4 | 9.4 TS1M0 |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP4 | 9.4 TS1M0 |
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 SP4 | 9.4 TS1M0 |
Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 SP4 | 9.4 TS1M0 |
Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP4 | 9.4 TS1M0 |
Microsoft Windows NT Workstation | 9.1 TS1M3 SP4 | |
64-bit Enabled HP-UX | 9.1 TS1M3 SP4 | 9.4 TS1M0 |
64-bit Enabled AIX | 9.1 TS1M3 SP4 | 9.4 TS1M0 |
Windows Vista for x64 | 9.1 TS1M3 SP4 | 9.4 TS1M0 |
Windows Vista | 9.1 TS1M3 SP4 | 9.4 TS1M0 |
Microsoft Windows XP Professional | 9.1 TS1M3 SP4 | 9.4 TS1M0 |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP4 | 9.4 TS1M0 |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP4 | 9.4 TS1M0 |
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP4 | 9.4 TS1M0 |
64-bit Enabled Solaris | 9.1 TS1M3 SP4 | 9.4 TS1M0 |
HP-UX IPF | 9.1 TS1M3 SP4 | 9.4 TS1M0 |
Linux | 9.1 TS1M3 SP4 | 9.4 TS1M0 |
Linux on Itanium | 9.1 TS1M3 SP4 | 9.4 TS1M0 |
OpenVMS Alpha | 9.1 TS1M3 SP4 | 9.4 TS1M0 |
Solaris for x64 | 9.1 TS1M3 SP4 | 9.4 TS1M0 |
Tru64 UNIX | 9.1 TS1M3 SP4 | 9.4 TS1M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | medium |
Date Modified: | 2012-12-12 09:46:05 |
Date Created: | 2012-08-29 08:42:35 |